package com.leoman.creator.dao;

import com.leoman.common.dao.IBaseJpaRepository;
import com.leoman.creator.entity.Creator;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by Administrator on 2016/6/14 0014.
 */
public interface CreatorDao extends IBaseJpaRepository<Creator> {

    @Query("select a from Creator a where a.status = 1 and a.id <> (select b.creator.id from UserInfo b where b.creator.id = a.id and b.status <> 1)")
    public List<Creator> iFindList();
}
